﻿CREATE TABLE [dbo].[LocalBanner] (
    [Id]                   INT          IDENTITY (1, 1) NOT NULL,
    [Nome]                 VARCHAR (50) NOT NULL,
    [CodigoInterno]        VARCHAR (10) NOT NULL,
    [Largura]              INT          NOT NULL,
    [Altura]               INT          NOT NULL,
    [SuportaAnimacaoFlash] BIT          DEFAULT ('1') NOT NULL,
    [TempoAnimacaoFlash]   TINYINT      DEFAULT ((15)) NOT NULL,
    [Valor]                MONEY        NOT NULL,
    [Quantidade]           TINYINT      DEFAULT ((1)) NOT NULL,
    [Ativo]                BIT          DEFAULT ('1') NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF),
    UNIQUE NONCLUSTERED ([Nome] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF) ON [PRIMARY]
);



